package com.gudaomai.wuye.mapper;

import com.gudaomai.wuye.entity.Butler;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.gudaomai.wuye.core.WuyeBaseMapper;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author zenghualu
 * @since 2017-09-01
 */
public interface ButlerMapper extends WuyeBaseMapper<Butler> {

	// 获取所有管家的姓名
	@Select("select name from tb_staff staff where staff.id in (select id_staff from tb_butler butler where butler.is_delete = 0) and staff.cf_duty_status = 0")
	public List<String> selectButlersName();
}